--------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\mitch\Dropbox\BLW\POP\Searching for a Bright Line\Replication Materials\Logs/BLW-f
> igures 5,6.log
  log type:  text
 opened on:   4 Dec 2018, 21:53:08

. 
. use "Data/BLW_Public_Waves3456.dta", clear
( )

. 
. 
. recode imp_misconduct-imp_investigations (0=0) (1=0) (2=1) (3=1) 
(imp_misconduct: 956 changes made)
(imp_private_gain: 917 changes made)
(imp_monitor_opponents: 925 changes made)
(imp_equal_rights: 952 changes made)
(imp_journalists: 896 changes made)
(imp_private_violence: 849 changes made)
(imp_free_speech: 934 changes made)
(imp_patriotism: 832 changes made)
(imp_foreign_influence: 919 changes made)
(imp_ban_ideology: 945 changes made)
(imp_voting_rights: 974 changes made)
(imp_votes_impact: 928 changes made)
(imp_election_fraud: 974 changes made)
(imp_expand_executive: 938 changes made)
(imp_legislature_check: 928 changes made)
(imp_judiciary_check: 930 changes made)
(imp_judicial_ind: 920 changes made)
(imp_participation: 910 changes made)
(imp_funds_transparent: 898 changes made)
(imp_contributions: 835 changes made)
(imp_opinions: 901 changes made)
(imp_districts: 891 changes made)
(imp_common_und: 921 changes made)
(imp_compromise: 841 changes made)
(imp_candidates_disclose: 932 changes made)
(imp_protest: 943 changes made)
(imp_investigations: 950 changes made)

. recode perf_misconduct-perf_investigations (1=0) (2=0) (3=1) (4=1) (5=.)
(perf_misconduct: 4063 changes made)
(perf_private_gain: 4065 changes made)
(perf_monitor_opponents: 4007 changes made)
(perf_equal_rights: 4028 changes made)
(perf_journalists: 4063 changes made)
(perf_private_violence: 4070 changes made)
(perf_free_speech: 4041 changes made)
(perf_patriotism: 4003 changes made)
(perf_foreign: 4019 changes made)
(perf_ban_ideology: 4054 changes made)
(perf_voting_rights: 4032 changes made)
(perf_votes_impact: 3980 changes made)
(perf_election_fraud: 4092 changes made)
(perf_expand_executive: 4046 changes made)
(perf_legislature_check: 4086 changes made)
(perf_judiciary_check: 4063 changes made)
(perf_judicial_ind: 3976 changes made)
(perf_participation: 3929 changes made)
(perf_funds_transparent: 3960 changes made)
(perf_contributions: 4042 changes made)
(perf_opinions: 4023 changes made)
(perf_districts: 3997 changes made)
(perf_common_und: 4001 changes made)
(perf_compromise: 3959 changes made)
(perf_candidates_disclose: 4025 changes made)
(perf_protest: 4074 changes made)
(perf_investigations: 4052 changes made)

. 
. tabstat imp_misconduct-imp_investigations if (wave==3) [aw=weight], format(%8.4f) col(statistics) la(2
> 5) var(25)

                 variable |      mean
--------------------------+----------
           imp_misconduct |    0.8375
         imp_private_gain |    0.8112
    imp_monitor_opponents |    0.7983
         imp_equal_rights |    0.8536
          imp_journalists |    0.7305
     imp_private_violence |    0.6830
          imp_free_speech |    0.7865
           imp_patriotism |    0.5345
    imp_foreign_influence |    0.8345
         imp_ban_ideology |    0.7904
        imp_voting_rights |    0.8873
         imp_votes_impact |    0.8232
       imp_election_fraud |    0.8978
     imp_expand_executive |    0.8254
    imp_legislature_check |    0.7856
      imp_judiciary_check |    0.7679
         imp_judicial_ind |    0.8179
        imp_participation |    0.7383
    imp_funds_transparent |    0.7170
        imp_contributions |    0.7033
             imp_opinions |    0.8251
            imp_districts |    0.7346
           imp_common_und |    0.7526
           imp_compromise |    0.5879
  imp_candidates_disclose |    0.8441
              imp_protest |    0.8157
       imp_investigations |    0.8376
-------------------------------------

. tabstat perf_misconduct-perf_investigations if (wave==6) [aw=weight], format(%8.4f) col(statistics) la
> (25) var(25)

                 variable |      mean
--------------------------+----------
          perf_misconduct |    0.2494
        perf_private_gain |    0.1624
   perf_monitor_opponents |    0.3052
        perf_equal_rights |    0.3837
         perf_journalists |    0.3674
    perf_private_violence |    0.2766
         perf_free_speech |    0.4788
          perf_patriotism |    0.1614
             perf_foreign |    0.3372
        perf_ban_ideology |    0.4939
       perf_voting_rights |    0.6001
        perf_votes_impact |    0.4071
      perf_election_fraud |    0.4388
    perf_expand_executive |    0.4526
   perf_legislature_check |    0.4319
     perf_judiciary_check |    0.4511
        perf_judicial_ind |    0.3923
       perf_participation |    0.3207
   perf_funds_transparent |    0.3095
       perf_contributions |    0.2276
            perf_opinions |    0.5150
           perf_districts |    0.2874
          perf_common_und |    0.1851
          perf_compromise |    0.1944
 perf_candidates_disclose |    0.4633
             perf_protest |    0.5482
      perf_investigations |    0.2585
-------------------------------------

. 
. 
. 
. * GENERATE AGGREGATED RESULTS FOR EXPERT SAMPLE
. 
. clear

. use "Data/BLW_Expert_Waves123456.dta", clear
( )

. 
. recode imp_misconduct-imp_investigations (0=0) (1=0) (2=1) (3=1)
(imp_misconduct: 2022 changes made)
(imp_private_gain: 1999 changes made)
(imp_monitor_opponents: 2032 changes made)
(imp_equal_rights: 2009 changes made)
(imp_journalists: 2013 changes made)
(imp_private_violence: 1994 changes made)
(imp_free_speech: 2024 changes made)
(imp_patriotism: 1861 changes made)
(imp_foreign_influence: 1979 changes made)
(imp_ban_ideology: 2024 changes made)
(imp_voting_rights: 2014 changes made)
(imp_votes_impact: 2005 changes made)
(imp_election_fraud: 2004 changes made)
(imp_expand_executive: 1980 changes made)
(imp_legislature_check: 1996 changes made)
(imp_judiciary_check: 1998 changes made)
(imp_judicial_ind: 502 changes made)
(imp_participation: 450 changes made)
(imp_funds_transparent: 473 changes made)
(imp_contributions: 434 changes made)
(imp_opinions: 468 changes made)
(imp_districts: 459 changes made)
(imp_common_und: 452 changes made)
(imp_compromise: 454 changes made)
(imp_candidates_disclose: 457 changes made)
(imp_protest: 471 changes made)
(imp_investigations: 457 changes made)

. label value imp_misconduct-imp_investigations statementlabel  

. 
. recode perf_misconduct-perf_investigations (1=0) (2=0) (3=1) (4=1) (5=.)
(perf_misconduct: 3952 changes made)
(perf_private_gain: 3921 changes made)
(perf_monitor_opponents: 3940 changes made)
(perf_equal_rights: 3990 changes made)
(perf_journalists: 3977 changes made)
(perf_private_violence: 3916 changes made)
(perf_free_speech: 3983 changes made)
(perf_patriotism: 4016 changes made)
(perf_foreign_influence: 3916 changes made)
(perf_ban_ideology: 3926 changes made)
(perf_voting_rights: 3968 changes made)
(perf_votes_impact: 3977 changes made)
(perf_election_fraud: 3957 changes made)
(perf_expand_executive: 3855 changes made)
(perf_legislature_check: 3921 changes made)
(perf_judiciary_check: 3924 changes made)
(perf_judicial_ind: 4021 changes made)
(perf_participation: 2450 changes made)
(perf_funds_transparent: 2468 changes made)
(perf_contributions: 2460 changes made)
(perf_opinions: 2426 changes made)
(perf_districts: 2449 changes made)
(perf_common_und: 2455 changes made)
(perf_compromise: 2459 changes made)
(perf_candidates_disclose: 2422 changes made)
(perf_protest: 2444 changes made)
(perf_investigations: 2376 changes made)

. label value perf_misconduct-perf_investigations statementlabel

. 
. tabstat imp_misconduct-imp_investigations if (wave==3), format(%8.4f) col(statistics) var(25)

                 variable |      mean
--------------------------+----------
           imp_misconduct |    0.9116
         imp_private_gain |    0.7705
    imp_monitor_opponents |    0.9703
         imp_equal_rights |    0.9760
          imp_journalists |    0.9710
     imp_private_violence |    0.9204
          imp_free_speech |    0.9698
           imp_patriotism |    0.4620
    imp_foreign_influence |    0.8178
         imp_ban_ideology |    0.9087
        imp_voting_rights |    0.9649
         imp_votes_impact |    0.8418
       imp_election_fraud |    0.9909
     imp_expand_executive |    0.8793
    imp_legislature_check |    0.8943
      imp_judiciary_check |    0.8798
         imp_judicial_ind |    0.9154
        imp_participation |    0.5556
    imp_funds_transparent |    0.7458
        imp_contributions |    0.7052
             imp_opinions |    0.9321
            imp_districts |    0.7759
           imp_common_und |    0.6688
           imp_compromise |    0.4990
  imp_candidates_disclose |    0.8584
              imp_protest |    0.9810
       imp_investigations |    0.9432
-------------------------------------

. tabstat perf_misconduct-perf_investigations if (wave==6), format(%8.4f) col(statistics) var(25)

                 variable |      mean
--------------------------+----------
          perf_misconduct |    0.3519
        perf_private_gain |    0.2139
   perf_monitor_opponents |    0.6011
        perf_equal_rights |    0.3837
         perf_journalists |    0.5831
    perf_private_violence |    0.6048
         perf_free_speech |    0.7872
          perf_patriotism |    0.1020
   perf_foreign_influence |    0.2834
        perf_ban_ideology |    0.8567
       perf_voting_rights |    0.3729
        perf_votes_impact |    0.2317
      perf_election_fraud |    0.7553
    perf_expand_executive |    0.3412
   perf_legislature_check |    0.3531
     perf_judiciary_check |    0.5731
        perf_judicial_ind |    0.5449
       perf_participation |    0.0920
   perf_funds_transparent |    0.3144
       perf_contributions |    0.1227
            perf_opinions |    0.7608
           perf_districts |    0.0728
          perf_common_und |    0.0780
          perf_compromise |    0.0833
 perf_candidates_disclose |    0.6703
             perf_protest |    0.8324
      perf_investigations |    0.4353
-------------------------------------

. 
. 
. 
. 
. * RESULTS ABOVE ARE COPIED AND PASTED IN TO EXCEL (OUTSIDE THE SCOPE OF THIS .DO FILE, THEN THE SYNTAX
>  BELOW GENERATES THE FIGURES
. * BOTH FIGURES ARE ORDERED BASED ON EXPERT IMPORTANCE
. 
. 
. clear

. import excel "Data/figures 5 and 6.xlsx", sheet("results") firstrow clear

. 
. 
. twoway scatter Perf6_Experts Imp3_Experts , graphregion(color(white)) mlabel (Order_Experts_Importance
> ) ///
> xlabel(0.4  "40%"  0.5  "50%"  0.6  "60%"  0.7  "70%"  0.8  "80%"  0.9  "90%"  1.0  "100%", labsize(3.
> 75) noticks grid gmin gmax)  ///
> ylabel(0  "0%"  0.1  "10%"  0.2  "20%"  0.3  "30%"  0.4  "40%"  0.5  "50%"  0.6  "60%"  0.7  "70%"  0.
> 8  "80%"  0.9  "90%"  1  "100%", labsize(3.75) noticks grid gmin gmax) ///
> mlabposition (0)  msymbol(i)  mlabcolor(green)  mlabsize(4)  ylabel(, angle(horizontal)) ///
> xtitle(" " `"Percentage who answered statement is "important""' `"or "essential" for democratic govern
> ment (Sept. 2017)"') ///
> ytitle(" " `"Percentage who answered U.S. "fully""'  `"or "mostly meets" standard (July 2018)"')  

. 
. graph export "Figures/Figure 5a (Experts).png", width(2000) replace
(file Figures/Figure 5a (Experts).png written in PNG format)

. graph export "Figures/Figure 5a (Experts).tif", width(10000) replace
(file Figures/Figure 5a (Experts).tif written in TIFF format)

. 
. 
. twoway scatter Perf6_Public Imp3_Public , graphregion(color(white)) mlabel (Order_Experts_Importance) 
> ///
> xlabel(0.4  "40%"  0.5  "50%"  0.6  "60%"  0.7  "70%"  0.8  "80%"  0.9  "90%"  1.0  "100%", labsize(3.
> 75) noticks grid gmin gmax)  ///
> ylabel(0  "0%"  0.1  "10%"  0.2  "20%"  0.3  "30%"  0.4  "40%"  0.5  "50%"  0.6  "60%"  0.7  "70%"  0.
> 8  "80%"  0.9  "90%"  1  "100%", labsize(3.75) noticks grid gmin gmax) ///
> mlabposition (0)  msymbol(i)  mlabcolor(purple)  mlabsize(4)  ylabel(, angle(horizontal)) ///
> xtitle(" " `"Percentage who answered statement is "important""' `"or "essential" for democratic govern
> ment (Sept. 2017)"') ///
> ytitle(" " `"Percentage who answered U.S. "fully""'  `"or "mostly meets" standard (July 2018)"')  

. 
. graph export "Figures/Figure 6a (Public).png", width(2000) replace
(file Figures/Figure 6a (Public).png written in PNG format)

. graph export "Figures/Figure 6a (Public).tif", width(10000) replace
(file Figures/Figure 6a (Public).tif written in TIFF format)

. 
. 
. log close
      name:  <unnamed>
       log:  C:\Users\mitch\Dropbox\BLW\POP\Searching for a Bright Line\Replication Materials\Logs/BLW-f
> igures 5,6.log
  log type:  text
 closed on:   4 Dec 2018, 21:53:30
--------------------------------------------------------------------------------------------------------
